package com.itheima.springboottilasmanager.mapper;


import com.itheima.springboottilasmanager.pojo.domain.OperateLog;
import com.itheima.springboottilasmanager.pojo.vo.queryString;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface OperateLogMapper {

    //插入日志数据
    @Insert("insert into operate_log (operate_emp_id, operate_time, class_name, method_name, method_params, return_value, cost_time) " +
            "values (#{operateEmpId}, #{operateTime}, #{className}, #{methodName}, #{methodParams}, #{returnValue}, #{costTime});")
     void insert(OperateLog log);
   @Select("select L.*,emp.name as operateEmpName from operate_log L left join emp on L.id = emp.id" )
    List<OperateLog> page(queryString qs);
}
